/*
WLVGoogleImageSelector - Google Picasa Web Plugin for Windows Live Writer
Copyright (C) 2007 Timothy Parez

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SQLite;
using System.IO;

namespace Arendee.WindowsLiveWriter.Plugins
{
    class DatabaseManager
    {
        static SQLiteConnection dbConnection;

        public static SQLiteConnection GetConnection()
        {
            if (DatabaseManager.dbConnection == null)
            {
                string databaseFile = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "wlvgoogleimageselector.s3db");
                DatabaseManager.dbConnection = new SQLiteConnection(String.Format("Data Source = {0}", databaseFile));

                //Create the database if it does not exist
                if (!File.Exists(databaseFile))
                {
                    SQLiteConnection.CreateFile(databaseFile);                    
                    SQLiteCommand createCommand = new SQLiteCommand("CREATE TABLE [googleimage] ([Id] VARCHAR(255)  UNIQUE NULL PRIMARY KEY,[Thumbnail] BLOB  NOT NULL,[LastUpdate] DATE  NULL)", dbConnection);
                    
                    dbConnection.Open();
                    createCommand.ExecuteNonQuery();
                    dbConnection.Close();  
                }
            }

            return DatabaseManager.dbConnection;    
        }
    }
}
